SUPPORT / SAMPLES & SAS NOTES
Problem Note 44087: Performing a SUBSTR function on a DB2 variable defined as a BLOB might result in a system abend 0C4
 |  |  |  |
Using the SUBSTR() function on a DB2 variable defined as a BLOB in SAS® 9.1 TS1M3 or later might result in an error similar to the following:
ERROR: System abend 0C4 occurred in module function sqxextr_get_next at offset 0000B2. ERROR: Traceback will be attempted... NOTE: Traceback called NOTE: Module Function Offset Line NOTE: -------- -------- ------ ---- NOTE: SASSQX @@669285 000308 0 sqxcrta_get_next NOTE: SASSQX @@669271 000A70 0 sqxcrta_open NOTE: SASSQX @@669257 0001CE 0 sqxcrta_init NOTE: SASSQX SQXEXEC 00012A 0 NOTE: SASSQX SQLLOOP 000DAC 0 NOTE: SASSQL SASSQL 000302 0 NOTE: SASHOST UNKNOWN 002DC0 0 ERROR: Delete current task.
Currently, SAS/ACCESS® Interface to DB2 in the z/OS environment does not support reading in DB2 data types of BLOB. There is no workaround for this problem.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.4 TS1M0 |